package com.zty.xiaomi.server.Mapper;

import com.zty.xiaomi.server.Entity.Service.Service;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public interface ServiceMapper {

    @Select("select service_id, service_name,status from service where status = 0")
    List<Service> getAllService();

    @Select("select service_id, service_name,status from service where status = 0 and service_id = #{service_id}")
    Service getServiceByServiceId(int service_id);
}
